Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# CURSOR_SPACE_FOR_TIME

Property | Description
--- | ---
Parameter type | Boolean
Default value | `false`
Modifiable | No
Range of values | `true | false`
Basic | No

`CURSOR_SPACE_FOR_TIME` lets you use more space for cursors in order to save time. It affects both the shared SQL area and the client's private SQL area.

Values:

- `TRUE`

  Shared SQL areas are kept pinned in the shared pool. As a result, shared SQL areas are not aged out of the pool as long as an open cursor references them. Because each active cursor's SQL area is present in memory, execution is faster. However, the shared SQL areas never leave memory while they are in use. Therefore, you should set this parameter to `TRUE` only when the shared pool is large enough to hold all open cursors simultaneously.

  In addition, a setting of `TRUE` retains the private SQL area allocated for each cursor between executions instead of discarding it after cursor execution, saving cursor allocation and initialization time

- `FALSE`

  Shared SQL areas can be deallocated from the library cache to make room for new SQL statements.

  Note: If this parameter is set to `TRUE`, the `SERIAL_REUSE` parameter is disabled.

  See Also: Oracle Database Concepts and Oracle Database Performance Tuning Guide "SERIAL _REUSE"